<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateSettingHintsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        /*
         * type = 1 首页-金额范围
         * 2 首页-还款试算
         * 3 提单-借款用途-每期还款
         * 4 审核通过 美体还款
         * 5 审核通过-借款人综合险
         * 6 放款中-每期还款
         * 7 还款计划表-其他
         */
        Schema::create('setting_hints', function (Blueprint $table) {
            $table->charset = "utf8";
            $table->collation = "utf8_general_ci";
            $table->comment = "系统的提示语";
            $table->increments('id');
            $table->unsignedTinyInteger("type")->comment("类型,不同类型对应不同的显示位置");
            $table->string("channel_code",127)->index()->default('0')->comment("对应setting_channel表的资方编号");
            $table->string('content')->default('')->comment("具体的内容");
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('setting_hints');
    }
}
